<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ValuesDataSet" targetNamespace="http://tempuri.org/ValuesDataSet.xsd" xmlns:mstns="http://tempuri.org/ValuesDataSet.xsd" xmlns="http://tempuri.org/ValuesDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ODDB" IsAppSettingsProperty="true" Modifier="Assembly" Name="ODDB (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ODDB.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ODConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="ODConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WaterOneFlow.odm.v1_1.Properties.Settings.GlobalReference.Default.ODConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataValuesTableAdapter" GeneratorDataComponentClassName="DataValuesTableAdapter" Name="DataValues" UserDataComponentName="DataValuesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.DataValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteID" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetDataBySiteID" GeneratorSourceName="FillBySiteID" GetMethodModifier="Public" GetMethodName="GetDataBySiteID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetDataBySiteID" UserSourceName="FillBySiteID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [DataValues] WHERE (([ValueID] = @Original_ValueID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValueID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValueID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [DataValues] ([DataValue], [ValueAccuracy], [LocalDateTime], [DateTimeUTC], [SiteID], [VariableID], [OffsetValue], [OffsetTypeID], [CensorCode], [QualifierID], [MethodID], [SourceID], [SampleID], [DerivedFromID], [QualityControlLevelID], [UTCOffset]) VALUES (@DataValue, @ValueAccuracy, @LocalDateTime, @DateTimeUTC, @SiteID, @VariableID, @OffsetValue, @OffsetTypeID, @CensorCode, @QualifierID, @MethodID, @SourceID, @SampleID, @DerivedFromID, @QualityControlLevelID, @UTCOffset)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DataValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DataValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ValueAccuracy" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ValueAccuracy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LocalDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTimeUTC" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTimeUTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VariableID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VariableID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OffsetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="OffsetValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OffsetTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CensorCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CensorCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualifierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualifierID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MethodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MethodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SampleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SampleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DerivedFromID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DerivedFromID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualityControlLevelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityControlLevelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UTCOffset" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UTCOffset" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ValueID, DataValue, ValueAccuracy, LocalDateTime, DateTimeUTC, SiteID, VariableID, OffsetValue, OffsetTypeID, CensorCode, QualifierID, MethodID, 
                      SourceID, SampleID, DerivedFromID, QualityControlLevelID, UTCOffset
FROM         DataValues
WHERE     (SiteID = @SiteID)
ORDER BY LocalDateTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SiteID" ColumnName="SiteID" DataSourceName="[D:\DEV2005\WATERONEFLOW\GENERICODWS\ODM1_1\BLANKDB\OD.MDF].dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [DataValues] SET [DataValue] = @DataValue, [ValueAccuracy] = @ValueAccuracy, [LocalDateTime] = @LocalDateTime, [DateTimeUTC] = @DateTimeUTC, [SiteID] = @SiteID, [VariableID] = @VariableID, [OffsetValue] = @OffsetValue, [OffsetTypeID] = @OffsetTypeID, [CensorCode] = @CensorCode, [QualifierID] = @QualifierID, [MethodID] = @MethodID, [SourceID] = @SourceID, [SampleID] = @SampleID, [DerivedFromID] = @DerivedFromID, [QualityControlLevelID] = @QualityControlLevelID, [UTCOffset] = @UTCOffset WHERE (([ValueID] = @Original_ValueID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DataValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DataValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ValueAccuracy" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ValueAccuracy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LocalDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTimeUTC" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTimeUTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VariableID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VariableID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OffsetValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="OffsetValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OffsetTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CensorCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CensorCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualifierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualifierID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MethodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MethodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SampleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SampleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DerivedFromID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DerivedFromID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualityControlLevelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityControlLevelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UTCOffset" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UTCOffset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValueID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValueID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ValueID" DataSetColumn="ValueID" />
              <Mapping SourceColumn="SiteID" DataSetColumn="SiteID" />
              <Mapping SourceColumn="VariableID" DataSetColumn="VariableID" />
              <Mapping SourceColumn="OffsetValue" DataSetColumn="OffsetValue" />
              <Mapping SourceColumn="OffsetTypeID" DataSetColumn="OffsetTypeID" />
              <Mapping SourceColumn="CensorCode" DataSetColumn="CensorCode" />
              <Mapping SourceColumn="QualifierID" DataSetColumn="QualifierID" />
              <Mapping SourceColumn="MethodID" DataSetColumn="MethodID" />
              <Mapping SourceColumn="SourceID" DataSetColumn="SourceID" />
              <Mapping SourceColumn="SampleID" DataSetColumn="SampleID" />
              <Mapping SourceColumn="DerivedFromID" DataSetColumn="DerivedFromID" />
              <Mapping SourceColumn="QualityControlLevelID" DataSetColumn="QualityControlLevelID" />
              <Mapping SourceColumn="DataValue" DataSetColumn="Value" />
              <Mapping SourceColumn="ValueAccuracy" DataSetColumn="AccuracyStdDev" />
              <Mapping SourceColumn="LocalDateTime" DataSetColumn="DateTime" />
              <Mapping SourceColumn="DateTimeUTC" DataSetColumn="DateTimeUTC" />
              <Mapping SourceColumn="UTCOffset" DataSetColumn="UTCOffset" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.DataValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteIDBetweenDates" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteIDBetweenDates" GeneratorSourceName="FillBySiteIDBetweenDates" GetMethodModifier="Public" GetMethodName="GetDataBySiteIDBetweenDates" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteIDBetweenDates" UserSourceName="FillBySiteIDBetweenDates">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CensorCode, DataValue, DateTimeUTC, DerivedFromID, LocalDateTime, MethodID, OffsetTypeID, OffsetValue, QualifierID, QualityControlLevelID, SampleID, SiteID, SourceID, UTCOffset, ValueAccuracy, ValueID, VariableID FROM DataValues WHERE (SiteID = @SiteID) AND (LocalDateTime BETWEEN @BeginDate AND @endDate) ORDER BY LocalDateTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SiteID" ColumnName="SiteID" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="BeginDate" ColumnName="LocalDateTime" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@BeginDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="endDate" ColumnName="LocalDateTime" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@endDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.DataValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteIDVariableID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteIDVariableID" GeneratorSourceName="FillBySiteIDVariableID" GetMethodModifier="Public" GetMethodName="GetDataBySiteIDVariableID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteIDVariableID" UserSourceName="FillBySiteIDVariableID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CensorCode, DataValue, DateTimeUTC, DerivedFromID, LocalDateTime, MethodID, OffsetTypeID, OffsetValue, QualifierID, QualityControlLevelID, SampleID, SiteID, SourceID, UTCOffset, ValueAccuracy, ValueID, VariableID FROM DataValues WHERE (SiteID = @SiteID) AND (VariableID = @VariableID) ORDER BY LocalDateTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SiteID" ColumnName="SiteID" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="VariableID" ColumnName="VariableID" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@VariableID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="VariableID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.DataValues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteIdVariableIDBetweenDates" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteIdVariableIDBetweenDates" GeneratorSourceName="FillBySiteIdVariableIDBetweenDates" GetMethodModifier="Public" GetMethodName="GetDataBySiteIdVariableIDBetweenDates" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteIdVariableIDBetweenDates" UserSourceName="FillBySiteIdVariableIDBetweenDates">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CensorCode, DataValue, DateTimeUTC, DerivedFromID, LocalDateTime, MethodID, OffsetTypeID, OffsetValue, QualifierID, QualityControlLevelID, SampleID, SiteID, SourceID, UTCOffset, ValueAccuracy, ValueID, VariableID FROM DataValues WHERE (SiteID = @SiteID) AND (VariableID = @VariableID) AND (LocalDateTime BETWEEN @BeingDate AND @EndDate) ORDER BY LocalDateTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SiteID" ColumnName="SiteID" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="VariableID" ColumnName="VariableID" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@VariableID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="VariableID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="BeingDate" ColumnName="LocalDateTime" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@BeingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndDate" ColumnName="LocalDateTime" DataSourceName="LittleBearRiver.dbo.DataValues" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LocalDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SourcesTableAdapter" GeneratorDataComponentClassName="SourcesTableAdapter" Name="Sources" UserDataComponentName="SourcesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.Sources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Sources] WHERE (([SourceID] = @Original_SourceID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Sources] ([Organization], [SourceDescription], [SourceLink], [ContactName], [Phone], [Email], [Address], [City], [State], [ZipCode], [Citation], [MetadataID]) VALUES (@Organization, @SourceDescription, @SourceLink, @ContactName, @Phone, @Email, @Address, @City, @State, @ZipCode, @Citation, @MetadataID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Organization" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Organization" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceLink" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Citation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Citation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MetadataID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MetadataID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     SourceID, Organization, SourceDescription, SourceLink, ContactName, Phone, Email, Address, City, State, ZipCode, Citation, MetadataID
FROM         Sources</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Sources] SET [Organization] = @Organization, [SourceDescription] = @SourceDescription, [SourceLink] = @SourceLink, [ContactName] = @ContactName, [Phone] = @Phone, [Email] = @Email, [Address] = @Address, [City] = @City, [State] = @State, [ZipCode] = @ZipCode, [Citation] = @Citation, [MetadataID] = @MetadataID WHERE (([SourceID] = @Original_SourceID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Organization" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Organization" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceLink" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Citation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Citation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MetadataID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MetadataID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SourceID" DataSetColumn="SourceID" />
              <Mapping SourceColumn="Organization" DataSetColumn="Organization" />
              <Mapping SourceColumn="SourceDescription" DataSetColumn="SourceDescription" />
              <Mapping SourceColumn="SourceLink" DataSetColumn="SourceLink" />
              <Mapping SourceColumn="ContactName" DataSetColumn="ContactName" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
              <Mapping SourceColumn="Citation" DataSetColumn="Citation" />
              <Mapping SourceColumn="MetadataID" DataSetColumn="MetadataID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MethodsTableAdapter" GeneratorDataComponentClassName="MethodsTableAdapter" Name="Methods" UserDataComponentName="MethodsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.Methods" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Methods] WHERE (([MethodID] = @Original_MethodID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MethodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MethodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Methods] ([MethodDescription], [MethodLink]) VALUES (@MethodDescription, @MethodLink)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MethodDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MethodDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MethodLink" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MethodLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Methods.*
FROM         Methods</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Methods] SET [MethodDescription] = @MethodDescription, [MethodLink] = @MethodLink WHERE (([MethodID] = @Original_MethodID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MethodDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MethodDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MethodLink" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MethodLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MethodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MethodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MethodID" DataSetColumn="MethodID" />
              <Mapping SourceColumn="MethodDescription" DataSetColumn="MethodDescription" />
              <Mapping SourceColumn="MethodLink" DataSetColumn="MethodLink" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OffsetTypesTableAdapter" GeneratorDataComponentClassName="OffsetTypesTableAdapter" Name="OffsetTypes" UserDataComponentName="OffsetTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.OffsetTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [OffsetTypes] WHERE (([OffsetTypeID] = @Original_OffsetTypeID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OffsetTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [OffsetTypes] ([OffsetUnitsID], [OffsetDescription]) VALUES (@OffsetUnitsID, @OffsetDescription)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OffsetUnitsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetUnitsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OffsetDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OffsetDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     OffsetTypeID, OffsetUnitsID, OffsetDescription
FROM         OffsetTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [OffsetTypes] SET [OffsetUnitsID] = @OffsetUnitsID, [OffsetDescription] = @OffsetDescription WHERE (([OffsetTypeID] = @Original_OffsetTypeID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OffsetUnitsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetUnitsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OffsetDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OffsetDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OffsetTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OffsetTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OffsetTypeID" DataSetColumn="OffsetTypeID" />
              <Mapping SourceColumn="OffsetUnitsID" DataSetColumn="OffsetUnitsID" />
              <Mapping SourceColumn="OffsetDescription" DataSetColumn="OffsetDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SamplesTableAdapter" GeneratorDataComponentClassName="SamplesTableAdapter" Name="Samples" UserDataComponentName="SamplesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Samples.SampleID, Samples.SampleType, Samples.LabSampleCode, LabMethods.LabName, LabMethods.LabOrganization, 
                      LabMethods.LabMethodName, LabMethods.LabMethodDescription, LabMethods.LabMethodLink
FROM         Samples INNER JOIN
                      LabMethods ON Samples.LabMethodID = LabMethods.LabMethodID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SampleID" DataSetColumn="SampleID" />
              <Mapping SourceColumn="SampleType" DataSetColumn="SampleType" />
              <Mapping SourceColumn="LabSampleCode" DataSetColumn="LabSampleCode" />
              <Mapping SourceColumn="LabName" DataSetColumn="LabName" />
              <Mapping SourceColumn="LabOrganization" DataSetColumn="LabOrganization" />
              <Mapping SourceColumn="LabMethodName" DataSetColumn="LabMethodName" />
              <Mapping SourceColumn="LabMethodDescription" DataSetColumn="LabMethodDescription" />
              <Mapping SourceColumn="LabMethodLink" DataSetColumn="LabMethodLink" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitsTableAdapter" GeneratorDataComponentClassName="UnitsTableAdapter" Name="Units" UserDataComponentName="UnitsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.Units" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Units] WHERE (([UnitsID] = @Original_UnitsID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Units] ([UnitsName], [UnitsType], [UnitsAbbreviation]) VALUES (@UnitsName, @UnitsType, @UnitsAbbreviation)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsAbbreviation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsAbbreviation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UnitsID, UnitsName, UnitsType, UnitsAbbreviation
FROM         Units</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Units] SET [UnitsName] = @UnitsName, [UnitsType] = @UnitsType, [UnitsAbbreviation] = @UnitsAbbreviation WHERE (([UnitsID] = @Original_UnitsID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitsAbbreviation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitsAbbreviation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UnitsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UnitsID" DataSetColumn="UnitsID" />
              <Mapping SourceColumn="UnitsName" DataSetColumn="UnitsName" />
              <Mapping SourceColumn="UnitsType" DataSetColumn="UnitsType" />
              <Mapping SourceColumn="UnitsAbbreviation" DataSetColumn="UnitsAbbreviation" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QualifiersTableAdapter" GeneratorDataComponentClassName="QualifiersTableAdapter" Name="Qualifiers" UserDataComponentName="QualifiersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.Qualifiers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Qualifiers] WHERE (([QualifierID] = @Original_QualifierID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualifierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualifierID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Qualifiers] ([QualifierCode], [QualifierDescription]) VALUES (@QualifierCode, @QualifierDescription)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualifierCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualifierCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualifierDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualifierDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Qualifiers.*
FROM         Qualifiers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Qualifiers] SET [QualifierCode] = @QualifierCode, [QualifierDescription] = @QualifierDescription WHERE (([QualifierID] = @Original_QualifierID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualifierCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualifierCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualifierDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualifierDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualifierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualifierID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QualifierID" DataSetColumn="QualifierID" />
              <Mapping SourceColumn="QualifierCode" DataSetColumn="QualifierCode" />
              <Mapping SourceColumn="QualifierDescription" DataSetColumn="QualifierDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QualityControlLevelsTableAdapter" GeneratorDataComponentClassName="QualityControlLevelsTableAdapter" Name="QualityControlLevels" UserDataComponentName="QualityControlLevelsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="dbo.QualityControlLevels" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [QualityControlLevels] WHERE (([QualityControlLevelID] = @Original_QualityControlLevelID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualityControlLevelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityControlLevelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [QualityControlLevels] ([QualityControlLevelCode], [Definition], [Explanation]) VALUES (@QualityControlLevelCode, @Definition, @Explanation)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualityControlLevelCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualityControlLevelCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Definition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Definition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Explanation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Explanation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     QualityControlLevels.*
FROM         QualityControlLevels</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [QualityControlLevels] SET [QualityControlLevelCode] = @QualityControlLevelCode, [Definition] = @Definition, [Explanation] = @Explanation WHERE (([QualityControlLevelID] = @Original_QualityControlLevelID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@QualityControlLevelCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="QualityControlLevelCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Definition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Definition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Explanation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Explanation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualityControlLevelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityControlLevelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QualityControlLevelID" DataSetColumn="QualityControlLevelID" />
              <Mapping SourceColumn="Definition" DataSetColumn="Definition" />
              <Mapping SourceColumn="Explanation" DataSetColumn="Explanation" />
              <Mapping SourceColumn="QualityControlLevelCode" DataSetColumn="QualityControlLevelCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CensorCodeCVTableAdapter" GeneratorDataComponentClassName="CensorCodeCVTableAdapter" Name="CensorCodeCV" UserDataComponentName="CensorCodeCVTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="LittleBear11.dbo.CensorCodeCV" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [CensorCodeCV] WHERE (([Term] = @Original_Term))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [CensorCodeCV] ([Term], [Definition]) VALUES (@Term, @Definition);
SELECT Term, Definition FROM CensorCodeCV WHERE (Term = @Term)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Definition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Definition" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Term, Definition
FROM         CensorCodeCV</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [CensorCodeCV] SET [Term] = @Term, [Definition] = @Definition WHERE (([Term] = @Original_Term));
SELECT Term, Definition FROM CensorCodeCV WHERE (Term = @Term)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Definition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Definition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Term" DataSetColumn="Term" />
              <Mapping SourceColumn="Definition" DataSetColumn="Definition" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ISOMetadataTableAdapter" GeneratorDataComponentClassName="ISOMetadataTableAdapter" Name="ISOMetadata" UserDataComponentName="ISOMetadataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODConnectionString (Settings)" DbObjectName="LittleBear11.dbo.ISOMetadata" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ISOMetadata.*
FROM            ISOMetadata</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MetadataID" DataSetColumn="MetadataID" />
              <Mapping SourceColumn="TopicCategory" DataSetColumn="TopicCategory" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Abstract" DataSetColumn="Abstract" />
              <Mapping SourceColumn="ProfileVersion" DataSetColumn="ProfileVersion" />
              <Mapping SourceColumn="MetadataLink" DataSetColumn="MetadataLink" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ValuesDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msdata:Prefix="WaterOneFlow.odws.v1_1" msprop:Generator_DataSetName="ValuesDataSet" msprop:Generator_UserDSName="ValuesDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Sources" msprop:Generator_UserTableName="Sources" msprop:Generator_RowEvArgName="SourcesRowChangeEvent" msprop:Generator_TableVarName="tableSources" msprop:Generator_TablePropName="Sources" msprop:Generator_RowDeletingName="SourcesRowDeleting" msprop:Generator_RowChangingName="SourcesRowChanging" msprop:Generator_RowDeletedName="SourcesRowDeleted" msprop:Generator_TableClassName="SourcesDataTable" msprop:Generator_RowChangedName="SourcesRowChanged" msprop:Generator_RowEvHandlerName="SourcesRowChangeEventHandler" msprop:Generator_RowClassName="SourcesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SourceID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn" msprop:Generator_UserColumnName="SourceID" type="xs:int" />
              <xs:element name="Organization" msprop:Generator_ColumnVarNameInTable="columnOrganization" msprop:Generator_ColumnPropNameInRow="Organization" msprop:Generator_ColumnPropNameInTable="OrganizationColumn" msprop:Generator_UserColumnName="Organization">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceDescription" msprop:Generator_ColumnVarNameInTable="columnSourceDescription" msprop:Generator_ColumnPropNameInRow="SourceDescription" msprop:Generator_ColumnPropNameInTable="SourceDescriptionColumn" msprop:Generator_UserColumnName="SourceDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceLink" msprop:Generator_ColumnVarNameInTable="columnSourceLink" msprop:Generator_ColumnPropNameInRow="SourceLink" msprop:Generator_ColumnPropNameInTable="SourceLinkColumn" msprop:Generator_UserColumnName="SourceLink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactName" msprop:Generator_ColumnVarNameInTable="columnContactName" msprop:Generator_ColumnPropNameInRow="ContactName" msprop:Generator_ColumnPropNameInTable="ContactNameColumn" msprop:Generator_UserColumnName="ContactName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" msprop:Generator_UserColumnName="ZipCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Citation" msprop:Generator_ColumnVarNameInTable="columnCitation" msprop:Generator_ColumnPropNameInRow="Citation" msprop:Generator_ColumnPropNameInTable="CitationColumn" msprop:Generator_UserColumnName="Citation">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetadataID" msprop:Generator_ColumnVarNameInTable="columnMetadataID" msprop:Generator_ColumnPropNameInRow="MetadataID" msprop:Generator_ColumnPropNameInTable="MetadataIDColumn" msprop:Generator_UserColumnName="MetadataID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Methods" msprop:Generator_UserTableName="Methods" msprop:Generator_RowEvArgName="MethodsRowChangeEvent" msprop:Generator_TableVarName="tableMethods" msprop:Generator_TablePropName="Methods" msprop:Generator_RowDeletingName="MethodsRowDeleting" msprop:Generator_RowChangingName="MethodsRowChanging" msprop:Generator_RowDeletedName="MethodsRowDeleted" msprop:Generator_TableClassName="MethodsDataTable" msprop:Generator_RowChangedName="MethodsRowChanged" msprop:Generator_RowEvHandlerName="MethodsRowChangeEventHandler" msprop:Generator_RowClassName="MethodsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MethodID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnMethodID" msprop:Generator_ColumnPropNameInRow="MethodID" msprop:Generator_ColumnPropNameInTable="MethodIDColumn" msprop:Generator_UserColumnName="MethodID" type="xs:int" />
              <xs:element name="MethodDescription" msprop:Generator_ColumnVarNameInTable="columnMethodDescription" msprop:Generator_ColumnPropNameInRow="MethodDescription" msprop:Generator_ColumnPropNameInTable="MethodDescriptionColumn" msprop:Generator_UserColumnName="MethodDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MethodLink" msprop:Generator_ColumnVarNameInTable="columnMethodLink" msprop:Generator_ColumnPropNameInRow="MethodLink" msprop:Generator_ColumnPropNameInTable="MethodLinkColumn" msprop:Generator_UserColumnName="MethodLink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OffsetTypes" msprop:Generator_UserTableName="OffsetTypes" msprop:Generator_RowEvArgName="OffsetTypesRowChangeEvent" msprop:Generator_TableVarName="tableOffsetTypes" msprop:Generator_TablePropName="OffsetTypes" msprop:Generator_RowDeletingName="OffsetTypesRowDeleting" msprop:Generator_RowChangingName="OffsetTypesRowChanging" msprop:Generator_RowDeletedName="OffsetTypesRowDeleted" msprop:Generator_TableClassName="OffsetTypesDataTable" msprop:Generator_RowChangedName="OffsetTypesRowChanged" msprop:Generator_RowEvHandlerName="OffsetTypesRowChangeEventHandler" msprop:Generator_RowClassName="OffsetTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OffsetTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnOffsetTypeID" msprop:Generator_ColumnPropNameInRow="OffsetTypeID" msprop:Generator_ColumnPropNameInTable="OffsetTypeIDColumn" msprop:Generator_UserColumnName="OffsetTypeID" type="xs:int" />
              <xs:element name="OffsetUnitsID" msprop:Generator_ColumnVarNameInTable="columnOffsetUnitsID" msprop:Generator_ColumnPropNameInRow="OffsetUnitsID" msprop:Generator_ColumnPropNameInTable="OffsetUnitsIDColumn" msprop:Generator_UserColumnName="OffsetUnitsID" type="xs:int" />
              <xs:element name="OffsetDescription" msprop:Generator_ColumnVarNameInTable="columnOffsetDescription" msprop:Generator_ColumnPropNameInRow="OffsetDescription" msprop:Generator_ColumnPropNameInTable="OffsetDescriptionColumn" msprop:Generator_UserColumnName="OffsetDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataValues" msprop:Generator_UserTableName="DataValues" msprop:Generator_RowEvArgName="DataValuesRowChangeEvent" msprop:Generator_TableVarName="tableDataValues" msprop:Generator_TablePropName="DataValues" msprop:Generator_RowDeletingName="DataValuesRowDeleting" msprop:Generator_RowChangingName="DataValuesRowChanging" msprop:Generator_RowDeletedName="DataValuesRowDeleted" msprop:Generator_TableClassName="DataValuesDataTable" msprop:Generator_RowChangedName="DataValuesRowChanged" msprop:Generator_RowEvHandlerName="DataValuesRowChangeEventHandler" msprop:Generator_RowClassName="DataValuesRow" minOccurs="0" maxOccurs="unbounded">
                <xs:annotation>
                  <xs:appinfo>
                    <msdata:Relationship name="Values_OffsetTypes" msdata:parent="OffsetTypes" msdata:child="DataValues" msdata:parentkey="OffsetTypeID" msdata:childkey="OffsetTypeID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetValuesRows" msprop:Generator_UserParentTable="OffsetTypes" msprop:Generator_UserRelationName="Values_OffsetTypes" msprop:Generator_RelationVarName="relationValues_OffsetTypes" msprop:Generator_ParentPropName="OffsetTypesRow" />
                  </xs:appinfo>
                </xs:annotation>
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="ValueID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnValueID" msprop:Generator_ColumnPropNameInRow="ValueID" msprop:Generator_ColumnPropNameInTable="ValueIDColumn" msprop:Generator_UserColumnName="ValueID" type="xs:long" />
                    <xs:element name="SiteID" msprop:Generator_ColumnVarNameInTable="columnSiteID" msprop:Generator_ColumnPropNameInRow="SiteID" msprop:Generator_ColumnPropNameInTable="SiteIDColumn" msprop:Generator_UserColumnName="SiteID" type="xs:int" />
                    <xs:element name="VariableID" msprop:Generator_ColumnVarNameInTable="columnVariableID" msprop:Generator_ColumnPropNameInRow="VariableID" msprop:Generator_ColumnPropNameInTable="VariableIDColumn" msprop:Generator_UserColumnName="VariableID" type="xs:int" />
                    <xs:element name="OffsetValue" msprop:Generator_ColumnVarNameInTable="columnOffsetValue" msprop:Generator_ColumnPropNameInRow="OffsetValue" msprop:Generator_ColumnPropNameInTable="OffsetValueColumn" msprop:Generator_UserColumnName="OffsetValue" type="xs:double" minOccurs="0" />
                    <xs:element name="OffsetTypeID" msprop:Generator_ColumnVarNameInTable="columnOffsetTypeID" msprop:Generator_ColumnPropNameInRow="OffsetTypeID" msprop:Generator_ColumnPropNameInTable="OffsetTypeIDColumn" msprop:Generator_UserColumnName="OffsetTypeID" type="xs:int" minOccurs="0" />
                    <xs:element name="CensorCode" msprop:Generator_ColumnVarNameInTable="columnCensorCode" msprop:Generator_ColumnPropNameInRow="CensorCode" msprop:Generator_ColumnPropNameInTable="CensorCodeColumn" msprop:Generator_UserColumnName="CensorCode">
                      <xs:simpleType>
                        <xs:restriction base="xs:string">
                          <xs:maxLength value="50" />
                        </xs:restriction>
                      </xs:simpleType>
                    </xs:element>
                    <xs:element name="QualifierID" msprop:Generator_ColumnVarNameInTable="columnQualifierID" msprop:Generator_ColumnPropNameInRow="QualifierID" msprop:Generator_ColumnPropNameInTable="QualifierIDColumn" msprop:Generator_UserColumnName="QualifierID" type="xs:int" minOccurs="0" />
                    <xs:element name="MethodID" msprop:Generator_ColumnVarNameInTable="columnMethodID" msprop:Generator_ColumnPropNameInRow="MethodID" msprop:Generator_ColumnPropNameInTable="MethodIDColumn" msprop:Generator_UserColumnName="MethodID" type="xs:int" />
                    <xs:element name="SourceID" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn" msprop:Generator_UserColumnName="SourceID" type="xs:int" />
                    <xs:element name="SampleID" msprop:Generator_ColumnVarNameInTable="columnSampleID" msprop:Generator_ColumnPropNameInRow="SampleID" msprop:Generator_ColumnPropNameInTable="SampleIDColumn" msprop:Generator_UserColumnName="SampleID" type="xs:int" minOccurs="0" />
                    <xs:element name="DerivedFromID" msprop:Generator_ColumnVarNameInTable="columnDerivedFromID" msprop:Generator_ColumnPropNameInRow="DerivedFromID" msprop:Generator_ColumnPropNameInTable="DerivedFromIDColumn" msprop:Generator_UserColumnName="DerivedFromID" type="xs:int" minOccurs="0" />
                    <xs:element name="QualityControlLevelID" msprop:Generator_ColumnVarNameInTable="columnQualityControlLevelID" msprop:Generator_ColumnPropNameInRow="QualityControlLevelID" msprop:Generator_ColumnPropNameInTable="QualityControlLevelIDColumn" msprop:Generator_UserColumnName="QualityControlLevelID" type="xs:int" />
                    <xs:element name="Value" msdata:Caption="DataValue" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnPropNameInTable="ValueColumn" msprop:Generator_UserColumnName="Value" type="xs:double" />
                    <xs:element name="AccuracyStdDev" msdata:Caption="ValueAccuracy" msprop:Generator_ColumnVarNameInTable="columnAccuracyStdDev" msprop:Generator_ColumnPropNameInRow="AccuracyStdDev" msprop:Generator_ColumnPropNameInTable="AccuracyStdDevColumn" msprop:Generator_UserColumnName="AccuracyStdDev" type="xs:double" minOccurs="0" />
                    <xs:element name="DateTime" msdata:Caption="LocalDateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" msprop:Generator_UserColumnName="DateTime" type="xs:dateTime" />
                    <xs:element name="DateTimeUTC" msprop:Generator_ColumnVarNameInTable="columnDateTimeUTC" msprop:Generator_ColumnPropNameInRow="DateTimeUTC" msprop:Generator_ColumnPropNameInTable="DateTimeUTCColumn" msprop:Generator_UserColumnName="DateTimeUTC" type="xs:dateTime" />
                    <xs:element name="UTCOffset" msprop:Generator_ColumnVarNameInTable="columnUTCOffset" msprop:Generator_ColumnPropNameInRow="UTCOffset" msprop:Generator_ColumnPropNameInTable="UTCOffsetColumn" msprop:Generator_UserColumnName="UTCOffset" type="xs:double" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Samples" msprop:Generator_UserTableName="Samples" msprop:Generator_RowEvArgName="SamplesRowChangeEvent" msprop:Generator_TableVarName="tableSamples" msprop:Generator_TablePropName="Samples" msprop:Generator_RowDeletingName="SamplesRowDeleting" msprop:Generator_RowChangingName="SamplesRowChanging" msprop:Generator_RowDeletedName="SamplesRowDeleted" msprop:Generator_TableClassName="SamplesDataTable" msprop:Generator_RowChangedName="SamplesRowChanged" msprop:Generator_RowEvHandlerName="SamplesRowChangeEventHandler" msprop:Generator_RowClassName="SamplesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SampleID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnSampleID" msprop:Generator_ColumnPropNameInRow="SampleID" msprop:Generator_ColumnPropNameInTable="SampleIDColumn" msprop:Generator_UserColumnName="SampleID" type="xs:int" />
              <xs:element name="SampleType" msprop:Generator_ColumnVarNameInTable="columnSampleType" msprop:Generator_ColumnPropNameInRow="SampleType" msprop:Generator_ColumnPropNameInTable="SampleTypeColumn" msprop:Generator_UserColumnName="SampleType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabSampleCode" msprop:Generator_ColumnVarNameInTable="columnLabSampleCode" msprop:Generator_ColumnPropNameInRow="LabSampleCode" msprop:Generator_ColumnPropNameInTable="LabSampleCodeColumn" msprop:Generator_UserColumnName="LabSampleCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabName" msprop:Generator_ColumnVarNameInTable="columnLabName" msprop:Generator_ColumnPropNameInRow="LabName" msprop:Generator_ColumnPropNameInTable="LabNameColumn" msprop:Generator_UserColumnName="LabName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabOrganization" msprop:Generator_ColumnVarNameInTable="columnLabOrganization" msprop:Generator_ColumnPropNameInRow="LabOrganization" msprop:Generator_ColumnPropNameInTable="LabOrganizationColumn" msprop:Generator_UserColumnName="LabOrganization">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabMethodName" msprop:Generator_ColumnVarNameInTable="columnLabMethodName" msprop:Generator_ColumnPropNameInRow="LabMethodName" msprop:Generator_ColumnPropNameInTable="LabMethodNameColumn" msprop:Generator_UserColumnName="LabMethodName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabMethodDescription" msprop:Generator_ColumnVarNameInTable="columnLabMethodDescription" msprop:Generator_ColumnPropNameInRow="LabMethodDescription" msprop:Generator_ColumnPropNameInTable="LabMethodDescriptionColumn" msprop:Generator_UserColumnName="LabMethodDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LabMethodLink" msprop:Generator_ColumnVarNameInTable="columnLabMethodLink" msprop:Generator_ColumnPropNameInRow="LabMethodLink" msprop:Generator_ColumnPropNameInTable="LabMethodLinkColumn" msprop:Generator_UserColumnName="LabMethodLink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Units" msprop:Generator_UserTableName="Units" msprop:Generator_RowEvArgName="UnitsRowChangeEvent" msprop:Generator_TableVarName="tableUnits" msprop:Generator_TablePropName="Units" msprop:Generator_RowDeletingName="UnitsRowDeleting" msprop:Generator_RowChangingName="UnitsRowChanging" msprop:Generator_RowDeletedName="UnitsRowDeleted" msprop:Generator_TableClassName="UnitsDataTable" msprop:Generator_RowChangedName="UnitsRowChanged" msprop:Generator_RowEvHandlerName="UnitsRowChangeEventHandler" msprop:Generator_RowClassName="UnitsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UnitsID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnUnitsID" msprop:Generator_ColumnPropNameInRow="UnitsID" msprop:Generator_ColumnPropNameInTable="UnitsIDColumn" msprop:Generator_UserColumnName="UnitsID" type="xs:int" />
              <xs:element name="UnitsName" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="UnitsName" msprop:Generator_ColumnVarNameInTable="columnUnitsName" msprop:Generator_ColumnPropNameInTable="UnitsNameColumn" msprop:Generator_UserColumnName="UnitsName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitsType" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="UnitsType" msprop:Generator_ColumnVarNameInTable="columnUnitsType" msprop:Generator_ColumnPropNameInTable="UnitsTypeColumn" msprop:Generator_UserColumnName="UnitsType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitsAbbreviation" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="UnitsAbbreviation" msprop:Generator_ColumnVarNameInTable="columnUnitsAbbreviation" msprop:Generator_ColumnPropNameInTable="UnitsAbbreviationColumn" msprop:Generator_UserColumnName="UnitsAbbreviation">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Qualifiers" msprop:Generator_UserTableName="Qualifiers" msprop:Generator_RowEvArgName="QualifiersRowChangeEvent" msprop:Generator_TableVarName="tableQualifiers" msprop:Generator_TablePropName="Qualifiers" msprop:Generator_RowDeletingName="QualifiersRowDeleting" msprop:Generator_RowChangingName="QualifiersRowChanging" msprop:Generator_RowDeletedName="QualifiersRowDeleted" msprop:Generator_TableClassName="QualifiersDataTable" msprop:Generator_RowChangedName="QualifiersRowChanged" msprop:Generator_RowEvHandlerName="QualifiersRowChangeEventHandler" msprop:Generator_RowClassName="QualifiersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QualifierID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnQualifierID" msprop:Generator_ColumnPropNameInRow="QualifierID" msprop:Generator_ColumnPropNameInTable="QualifierIDColumn" msprop:Generator_UserColumnName="QualifierID" type="xs:int" />
              <xs:element name="QualifierCode" msprop:Generator_ColumnVarNameInTable="columnQualifierCode" msprop:Generator_ColumnPropNameInRow="QualifierCode" msprop:Generator_ColumnPropNameInTable="QualifierCodeColumn" msprop:Generator_UserColumnName="QualifierCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QualifierDescription" msprop:Generator_ColumnVarNameInTable="columnQualifierDescription" msprop:Generator_ColumnPropNameInRow="QualifierDescription" msprop:Generator_ColumnPropNameInTable="QualifierDescriptionColumn" msprop:Generator_UserColumnName="QualifierDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QualityControlLevels" msprop:Generator_UserTableName="QualityControlLevels" msprop:Generator_RowEvArgName="QualityControlLevelsRowChangeEvent" msprop:Generator_TableVarName="tableQualityControlLevels" msprop:Generator_TablePropName="QualityControlLevels" msprop:Generator_RowDeletingName="QualityControlLevelsRowDeleting" msprop:Generator_RowChangingName="QualityControlLevelsRowChanging" msprop:Generator_RowDeletedName="QualityControlLevelsRowDeleted" msprop:Generator_TableClassName="QualityControlLevelsDataTable" msprop:Generator_RowChangedName="QualityControlLevelsRowChanged" msprop:Generator_RowEvHandlerName="QualityControlLevelsRowChangeEventHandler" msprop:Generator_RowClassName="QualityControlLevelsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QualityControlLevelID" msprop:Generator_ColumnVarNameInTable="columnQualityControlLevelID" msprop:Generator_ColumnPropNameInRow="QualityControlLevelID" msprop:Generator_ColumnPropNameInTable="QualityControlLevelIDColumn" msprop:Generator_UserColumnName="QualityControlLevelID" type="xs:int" />
              <xs:element name="Definition" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Definition" msprop:Generator_ColumnVarNameInTable="columnDefinition" msprop:Generator_ColumnPropNameInTable="DefinitionColumn" msprop:Generator_UserColumnName="Definition">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Explanation" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="Explanation" msprop:Generator_ColumnVarNameInTable="columnExplanation" msprop:Generator_ColumnPropNameInTable="ExplanationColumn" msprop:Generator_UserColumnName="Explanation">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QualityControlLevelCode" msprop:Generator_ColumnVarNameInTable="columnQualityControlLevelCode" msprop:Generator_ColumnPropNameInRow="QualityControlLevelCode" msprop:Generator_ColumnPropNameInTable="QualityControlLevelCodeColumn" msprop:Generator_UserColumnName="QualityControlLevelCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CensorCodeCV" msprop:Generator_UserTableName="CensorCodeCV" msprop:Generator_RowEvArgName="CensorCodeCVRowChangeEvent" msprop:Generator_TableVarName="tableCensorCodeCV" msprop:Generator_TablePropName="CensorCodeCV" msprop:Generator_RowDeletingName="CensorCodeCVRowDeleting" msprop:Generator_RowChangingName="CensorCodeCVRowChanging" msprop:Generator_RowDeletedName="CensorCodeCVRowDeleted" msprop:Generator_TableClassName="CensorCodeCVDataTable" msprop:Generator_RowChangedName="CensorCodeCVRowChanged" msprop:Generator_RowEvHandlerName="CensorCodeCVRowChangeEventHandler" msprop:Generator_RowClassName="CensorCodeCVRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Term" msprop:Generator_ColumnVarNameInTable="columnTerm" msprop:Generator_ColumnPropNameInRow="Term" msprop:Generator_ColumnPropNameInTable="TermColumn" msprop:Generator_UserColumnName="Term">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Definition" msprop:Generator_ColumnVarNameInTable="columnDefinition" msprop:Generator_ColumnPropNameInRow="Definition" msprop:Generator_ColumnPropNameInTable="DefinitionColumn" msprop:Generator_UserColumnName="Definition" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ISOMetadata" msprop:Generator_TableClassName="ISOMetadataDataTable" msprop:Generator_RowEvArgName="ISOMetadataRowChangeEvent" msprop:Generator_TableVarName="tableISOMetadata" msprop:Generator_TablePropName="ISOMetadata" msprop:Generator_RowDeletingName="ISOMetadataRowDeleting" msprop:Generator_UserTableName="ISOMetadata" msprop:Generator_RowChangingName="ISOMetadataRowChanging" msprop:Generator_RowDeletedName="ISOMetadataRowDeleted" msprop:Generator_RowChangedName="ISOMetadataRowChanged" msprop:Generator_RowEvHandlerName="ISOMetadataRowChangeEventHandler" msprop:Generator_RowClassName="ISOMetadataRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MetadataID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnMetadataID" msprop:Generator_ColumnPropNameInRow="MetadataID" msprop:Generator_ColumnPropNameInTable="MetadataIDColumn" msprop:Generator_UserColumnName="MetadataID" type="xs:int" />
              <xs:element name="TopicCategory" msprop:Generator_ColumnVarNameInTable="columnTopicCategory" msprop:Generator_ColumnPropNameInRow="TopicCategory" msprop:Generator_ColumnPropNameInTable="TopicCategoryColumn" msprop:Generator_UserColumnName="TopicCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Abstract" msprop:Generator_ColumnVarNameInTable="columnAbstract" msprop:Generator_ColumnPropNameInRow="Abstract" msprop:Generator_ColumnPropNameInTable="AbstractColumn" msprop:Generator_UserColumnName="Abstract">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProfileVersion" msprop:Generator_ColumnVarNameInTable="columnProfileVersion" msprop:Generator_ColumnPropNameInRow="ProfileVersion" msprop:Generator_ColumnPropNameInTable="ProfileVersionColumn" msprop:Generator_UserColumnName="ProfileVersion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetadataLink" msprop:Generator_ColumnVarNameInTable="columnMetadataLink" msprop:Generator_ColumnPropNameInRow="MetadataLink" msprop:Generator_ColumnPropNameInTable="MetadataLinkColumn" msprop:Generator_UserColumnName="MetadataLink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sources" />
      <xs:field xpath="mstns:SourceID" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:Sources" />
      <xs:field xpath="mstns:MetadataID" />
    </xs:unique>
    <xs:unique name="Methods_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Methods" />
      <xs:field xpath="mstns:MethodID" />
    </xs:unique>
    <xs:unique name="DataValues_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DataValues" />
      <xs:field xpath="mstns:ValueID" />
    </xs:unique>
    <xs:unique name="OffsetTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OffsetTypes" />
      <xs:field xpath="mstns:OffsetTypeID" />
    </xs:unique>
    <xs:unique name="Samples_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Samples" />
      <xs:field xpath="mstns:SampleID" />
    </xs:unique>
    <xs:unique name="Units_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Units" />
      <xs:field xpath="mstns:UnitsID" />
    </xs:unique>
    <xs:unique name="Qualifiers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Qualifiers" />
      <xs:field xpath="mstns:QualifierID" />
    </xs:unique>
    <xs:unique name="QualityControlLevels_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QualityControlLevels" />
      <xs:field xpath="mstns:QualityControlLevelID" />
    </xs:unique>
    <xs:unique name="CensorCodeCV_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CensorCodeCV" />
      <xs:field xpath="mstns:Term" />
    </xs:unique>
    <xs:unique name="ISOMetadata_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ISOMetadata" />
      <xs:field xpath="mstns:MetadataID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Values_Sources" msdata:parent="Sources" msdata:child="DataValues" msdata:parentkey="SourceID" msdata:childkey="SourceID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetValuesRows" msprop:Generator_UserParentTable="Sources" msprop:Generator_UserRelationName="FK_Values_Sources" msprop:Generator_RelationVarName="relationFK_Values_Sources" msprop:Generator_ParentPropName="SourcesRow" />
      <msdata:Relationship name="Values_Samples" msdata:parent="Samples" msdata:child="DataValues" msdata:parentkey="SampleID" msdata:childkey="SampleID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetValuesRows" msprop:Generator_UserParentTable="Samples" msprop:Generator_UserRelationName="Values_Samples" msprop:Generator_RelationVarName="relationValues_Samples" msprop:Generator_ParentPropName="SamplesRow" />
      <msdata:Relationship name="FK_Values_Methods" msdata:parent="Methods" msdata:child="DataValues" msdata:parentkey="MethodID" msdata:childkey="MethodID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetValuesRows" msprop:Generator_UserParentTable="Methods" msprop:Generator_UserRelationName="FK_Values_Methods" msprop:Generator_RelationVarName="relationFK_Values_Methods" msprop:Generator_ParentPropName="MethodsRow" />
      <msdata:Relationship name="OffsetTypes_FK00" msdata:parent="Units" msdata:child="OffsetTypes" msdata:parentkey="UnitsID" msdata:childkey="OffsetUnitsID" msprop:Generator_UserChildTable="OffsetTypes" msprop:Generator_ChildPropName="GetOffsetTypesRows" msprop:Generator_UserParentTable="Units" msprop:Generator_UserRelationName="OffsetTypes_FK00" msprop:Generator_RelationVarName="relationOffsetTypes_FK00" msprop:Generator_ParentPropName="UnitsRow" />
      <msdata:Relationship name="FK_Values_Qualifiers" msdata:parent="Qualifiers" msdata:child="DataValues" msdata:parentkey="QualifierID" msdata:childkey="QualifierID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetValuesRows" msprop:Generator_UserParentTable="Qualifiers" msprop:Generator_UserRelationName="FK_Values_Qualifiers" msprop:Generator_RelationVarName="relationFK_Values_Qualifiers" msprop:Generator_ParentPropName="QualifiersRow" />
      <msdata:Relationship name="FK_Values_QualityControlLevelDefinitions" msdata:parent="QualityControlLevels" msdata:child="DataValues" msdata:parentkey="QualityControlLevelID" msdata:childkey="QualityControlLevelID" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetDataValuesRows" msprop:Generator_UserParentTable="QualityControlLevels" msprop:Generator_UserRelationName="FK_Values_QualityControlLevelDefinitions" msprop:Generator_RelationVarName="relationFK_Values_QualityControlLevelDefinitions" msprop:Generator_ParentPropName="QualityControlLevelsRow" />
      <msdata:Relationship name="FK_DataValues_CensorCodeCV" msdata:parent="CensorCodeCV" msdata:child="DataValues" msdata:parentkey="Term" msdata:childkey="CensorCode" msprop:Generator_UserChildTable="DataValues" msprop:Generator_ChildPropName="GetDataValuesRows" msprop:Generator_UserParentTable="CensorCodeCV" msprop:Generator_UserRelationName="FK_DataValues_CensorCodeCV" msprop:Generator_RelationVarName="relationFK_DataValues_CensorCodeCV" msprop:Generator_ParentPropName="CensorCodeCVRow" />
      <msdata:Relationship name="FK_Sources_ISOMetaData" msdata:parent="ISOMetadata" msdata:child="Sources" msdata:parentkey="MetadataID" msdata:childkey="MetadataID" msprop:Generator_UserChildTable="Sources" msprop:Generator_ChildPropName="GetSourcesRows" msprop:Generator_UserParentTable="ISOMetadata" msprop:Generator_UserRelationName="FK_Sources_ISOMetaData" msprop:Generator_RelationVarName="relationFK_Sources_ISOMetaData" msprop:Generator_ParentPropName="ISOMetadataRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>